package com.dwjm.shop.merchant;

import com.dwjm.shop.utils.ConnectionDatabaseForMySQLUseJdbc;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class MerchantDaoImpl implements MerchantDao{
    Connection connection = null;
    PreparedStatement pstmt = null;
    ResultSet rset = null;

    public MerchantDaoImpl(){
        connection = ConnectionDatabaseForMySQLUseJdbc.getConnection();
    }

    @Override
    public boolean login(String account, String password) {
        try {
          PreparedStatement preparedStatement = connection.prepareStatement("select account from t_merchant where account = ? and  password = ?");
          preparedStatement.setString(1,account);
          preparedStatement.setString(2,password);
          rset = preparedStatement.executeQuery();
          if (rset.next()){
              return true;
          }
        }catch (Exception e){
            e.printStackTrace();
        }
        return false;
    }
}
